/* ---------------------------------------------------------------------- */
/* Script generated with: DeZign for Databases v5.2.3                     */
/* Target DBMS:           MS SQL Server 2005                              */
/* Project file:          blue_pumpkin_diagram.dez                        */
/* Project name:                                                          */
/* Author:                                                                */
/* Script type:           Database drop script                            */
/* Created on:            2010-07-16 04:55                                */
/* Model version:         Version 2010-07-16                              */
/* ---------------------------------------------------------------------- */


/* ---------------------------------------------------------------------- */
/* Drop foreign key constraints                                           */
/* ---------------------------------------------------------------------- */

ALTER TABLE [Users] DROP CONSTRAINT [M_Roles_Users]
GO

ALTER TABLE [UserProfiles] DROP CONSTRAINT [Users_UserProfiles]
GO

ALTER TABLE [Events] DROP CONSTRAINT [Types_Events]
GO

ALTER TABLE [Requests] DROP CONSTRAINT [Users_Requests]
GO

ALTER TABLE [Requests] DROP CONSTRAINT [Events_Requests]
GO

ALTER TABLE [T_EventPrizes] DROP CONSTRAINT [Users_T_EventPrizes]
GO

ALTER TABLE [T_EventPrizes] DROP CONSTRAINT [Events_T_EventPrizes]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "Users"                                                     */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Users] DROP CONSTRAINT [DEF_Users_password]
GO

ALTER TABLE [Users] DROP CONSTRAINT [DEF_Users_createdate]
GO

ALTER TABLE [Users] DROP CONSTRAINT [DEF_Users_status]
GO

ALTER TABLE [Users] DROP CONSTRAINT [PK_Users]
GO

/* Drop table */

DROP TABLE [Users]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "UserProfiles"                                              */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [UserProfiles] DROP CONSTRAINT [PK_UserProfiles]
GO

/* Drop table */

DROP TABLE [UserProfiles]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "M_Roles"                                                   */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [M_Roles] DROP CONSTRAINT [PK_M_Roles]
GO

/* Drop table */

DROP TABLE [M_Roles]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "FAQS"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [FAQS] DROP CONSTRAINT [DEF_FAQS_createdate]
GO

ALTER TABLE [FAQS] DROP CONSTRAINT [DEF_FAQS_status]
GO

ALTER TABLE [FAQS] DROP CONSTRAINT [PK_FAQS]
GO

/* Drop table */

DROP TABLE [FAQS]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "Types"                                                     */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Types] DROP CONSTRAINT [PK_Types]
GO

/* Drop table */

DROP TABLE [Types]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "Events"                                                    */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Events] DROP CONSTRAINT [DEF_Events_createdate]
GO

ALTER TABLE [Events] DROP CONSTRAINT [DEF_Events_status]
GO

ALTER TABLE [Events] DROP CONSTRAINT [PK_Events]
GO

/* Drop table */

DROP TABLE [Events]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "Requests"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [Requests] DROP CONSTRAINT [DEF_Requests_status]
GO

ALTER TABLE [Requests] DROP CONSTRAINT [PK_Requests]
GO

/* Drop table */

DROP TABLE [Requests]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "T_EventPrizes"                                             */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [T_EventPrizes] DROP CONSTRAINT [PK_T_EventPrizes]
GO

/* Drop table */

DROP TABLE [T_EventPrizes]
GO
